package com.cloud.drore.eboss.supplier.mapper.provider;

/**
 * 浙江卓锐科技股份有限公司 版权所有  Copyright 2018<br>
 *
 * @Description: <br>
 * @Project: eboos <br>
 * @CreateDate: Created in 2018/1/18 16:40 <br>
 * @Author: <a href="575842778@qq.com">郑永涛</a>
 */
public class CombinationProductRelationProvider {
    public CombinationProductRelationProvider(){

    }

    public String selectTicketInfoByCombinationProductId(Long combinationProductId){
        String sql = "select ticket.is_real_name" +
                " from eboos_combination_product_relation proRelation " +
                " inner join eboos_ticket ticket on proRelation.product_id = ticket.id " +
                "  where ticket.is_deleted = 0  " +
                " and proRelation.combination_product_id = "+combinationProductId+" ";
        return sql;
    }

}